Tabela StockDocument

Definicja tabeli StockDocument

Name

StockDocument

Code

StockDocument

Comment

 


Lista kolumn tabeli StockDocument

Name

Code

StockDocumentID

StockDocumentID

StockDocumentTypeID

StockDocumentTypeID

StockID

StockID

CostAccountID

CostAccountID

PersonID

PersonID

DateValue

DateValue

Comments

Comments

InsertingPerson

InsertingPerson

LastModifiedDT

LastModifiedDT

LastModifiedPerson

LastModifiedPerson

InsertDate

InsertDate


Kolumna StockDocumentID tabeli StockDocument

Definicja kolumny StockDocumentID tabeli StockDocument

Name

StockDocumentID

Code

StockDocumentID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StockDocumentTypeID tabeli StockDocument

Definicja kolumny StockDocumentTypeID tabeli StockDocument

Name

StockDocumentTypeID

Code

StockDocumentTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StockID tabeli StockDocument

Definicja kolumny StockID tabeli StockDocument

Name

StockID

Code

StockID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CostAccountID tabeli StockDocument

Definicja kolumny CostAccountID tabeli StockDocument

Name

CostAccountID

Code

CostAccountID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonID tabeli StockDocument

Definicja kolumny PersonID tabeli StockDocument

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DateValue tabeli StockDocument

Definicja kolumny DateValue tabeli StockDocument

Name

DateValue

Code

DateValue

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Comments tabeli StockDocument

Definicja kolumny Comments tabeli StockDocument

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna InsertingPerson tabeli StockDocument

Definicja kolumny InsertingPerson tabeli StockDocument

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

PL: Osoba wstawiajaca rekord
EN: Person inserting record


Kolumna LastModifiedDT tabeli StockDocument

Definicja kolumny LastModifiedDT tabeli StockDocument

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Kolumna LastModifiedPerson tabeli StockDocument

Definicja kolumny LastModifiedPerson tabeli StockDocument

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InsertDate tabeli StockDocument

Definicja kolumny InsertDate tabeli StockDocument

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Lista kluczy tabeli StockDocument

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli StockDocument

Definicja klucza Identifier_1 tabeli StockDocument

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment